MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Artist Role = 1781

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Department, Object Name, Artist Prefix, Artist Nationality, City, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
218281 52.502.1 0 0 345784 Drawings and Prints 11 Book 97 Collection of Ornament: Lunettes, Cartouches, Friezes           Designer|Engraver|Engraver 1781 Designed by|Engraved by|Engraved by Francesco Bedeschini|Anton Pau|Cesario Fantitti     Bedeschini, Francesco|Pau, Anton|Fantitti, Cesario 21729 Italian|Italian?|Italian 1257     1672–1701 1672 1701 Engravings 29296   The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1952                       Books 442   Metropolitan Museum of Art, New York, NY 1
219604 42.142 0 1 347124 Drawings and Prints 11 Book 97 Jardin de Monceau           Designer|Engraver|Engraver 1781   Louis de Carmontelle|Jean Charles Delafosse|Louis Joseph Masquelier French, Paris 1717–1806 Paris|French, Paris 1734–1789 Paris|French, Cysoing 1741–1811 Paris   Carmontelle, Louis de|Delafosse, Jean Charles|Masquelier, Louis Joseph 22680 French|French|French 103 1717 |1734 |1741 1806 |1789 |1811 1779 1779 1779 Engraving 7208 Overall: 22 7/16 x 16 1/8 x 1 in. (57 x 41 x 2.5 cm) Harris Brisbane Dick Fund, 1942   Paris 27                   Books 442   Metropolitan Museum of Art, New York, NY 1
227734 45.86.2 0 0 355354 Drawings and Prints 11 Book 97 Vita de S. Filippo Neri           Designer|Engraver|Engraver 1781 Designed by Jacques Stella|Luca Ciamberlano|Christiano Sas French, Lyons 1596–1657 Paris|Italian, active Rome, 1599–1641   Stella, Jacques|Ciamberlano, Luca|Sas, Christiano 28587 French|Italian|French 273 1596 |1599 1657 |1641 n.d. 1596 1641     Harris Brisbane Dick Fund, 1945                       Books 442   Metropolitan Museum of Art, New York, NY 1
228722 41.115.1 0 1 356360 Drawings and Prints 11 Book Print Ornament & Architecture 13888 T'Magazin oft Pac-huys der Loffelÿcker Penn-const (The Store Room or Ware House of the Praiseworthy Art of the Pen)           Designer|Engraver|Engraver 1781 Designed by|Portrait of Roelands engraved by|Engraved by David Roelands|F. Schelemans|Simon Wynhoutsz Frisius Netherlandish, active 17th century|Netherlandish, active 17th century|Netherlandish, Harlingen ca. 1580–ca. 1628 The Hague   Roelands, David|Schelemans, F.|Frisius, Simon Wynhoutsz 29207 Netherlandish|Netherlandish|Netherlandish 787 0017 |1600 |1580 0017 |1700 |1628 1616 1616 1616 plates: etching, woodcut 34217 9 5/8 × 14 3/4 × 13/16 in. (24.5 × 37.5 × 2.1 cm) Harris Brisbane Dick Fund, 1941   Vlissingen 1405                   Books|Prints|Ornament & Architecture 679   Metropolitan Museum of Art, New York, NY 1
241140 53.685.282 0 0 369272 Drawings and Prints 11 Album 1119 Emblemata Evangelica           Designer|Engraver|Engraver 1781 Designed by|Engraved by|Engraved by Hans Bol|Sadeler (unspecified member of the Sadeler family)|Adriaen Collaert Netherlandish, Mechelen 1534–1593 Amsterdam|Netherlandish, mid-16th century–mid-17th century|Netherlandish, Antwerp ca. 1560–1618 Antwerp   Bol, Hans|Sadeler|Collaert, Adriaen 33523 Netherlandish|Netherlandish|Netherlandish 787 1534 |1550 |1560 1593 |1650 |1618 16th century 1500 1599 plates: engraving 33820 Overall: 10 13/16 x 9 1/16 in. (27.5 x 23 cm) Gift of Eugene L. Garbaty, 1953                       Albums|Prints 462   Metropolitan Museum of Art, New York, NY 1
413288 BV4823 .D48 1741 1 1 681547 The Libraries 20   De l'imitation de Jesus-Christ, traduction nouvelle ; ornée de figures en taille-douce           Designer|Engraver|Engraver 1781 Engravings drawn by Antoine Humblot|J. B. Guélard|Claude Duflos French, died 1758|French, active ca. 1730|French, Coucy-le-Château 1665–1727 Paris   Humblot, Antoine|Guélard, J. B.|Duflos, Claude 52069 French|French|French 103 1658 |1730 |1665 1758 |1730 |1727 1741 1741 1741   [8], xx, 608 p., [4] leaves of plates ; ill. (engravings) ; Height: 8 1/4 in. (21 cm) Gift of Jayne Wrightsman, 2008   Paris 27     France 9             | 259   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 135.779ms · Data license: CC0 · Data source: metmuseum/openaccess